FaAcademicYear

Logical Entity Name | FaAcademicYear
Default Table Name | FaAcademicYear
Physical Only | NO
Owner | dbo
Definition |
Note |

FaAcademicYear Columns

ColumnName | Domain | Datatype | NULL | Definition
FaAcademicYearID |  | int | NO |
Code |  | char(8) | NO |
Descrip |  | varchar(40) | NO |
FaPackMethID |  | int | YES |
DefaultWeeksInAY |  | smallint | YES |
DefaultWeeksNonEnroll |  | smallint | YES |
NumDisbPell |  | smallint | YES |
NumDisbGrant |  | smallint | YES |
NumDisbLoan |  | smallint | YES |
NumDisbPerkins |  | smallint | YES |
NumDisbOther |  | smallint | YES |
NumDisbWS |  | smallint | YES |
Disb1PctPell |  | numeric(6, 2) | YES |
Disb2PctPell |  | numeric(6, 2) | YES |
Disb3PctPell |  | numeric(6, 2) | YES |
Disb4PctPell |  | numeric(6, 2) | YES |
Disb5PctPell |  | numeric(6, 2) | YES |
Disb1PctGrant |  | numeric(6, 2) | YES |
Disb2PctGrant |  | numeric(6, 2) | YES |
Disb3PctGrant |  | numeric(6, 2) | YES |
Disb4PctGrant |  | numeric(6, 2) | YES |
Disb5PctGrant |  | numeric(6, 2) | YES |
Disb1PctLoan |  | numeric(6, 2) | YES |
Disb2PctLoan |  | numeric(6, 2) | YES |
Disb3PctLoan |  | numeric(6, 2) | YES |
Disb4PctLoan |  | numeric(6, 2) | YES |
Disb5PctLoan |  | numeric(6, 2) | YES |
Disb1PctPerkins |  | numeric(6, 2) | YES |
Disb2PctPerkins |  | numeric(6, 2) | YES |
Disb3PctPerkins |  | numeric(6, 2) | YES |
Disb4PctPerkins |  | numeric(6, 2) | YES |
Disb5PctPerkins |  | numeric(6, 2) | YES |
Disb1PctOther |  | numeric(6, 2) | YES |
Disb2PctOther |  | numeric(6, 2) | YES |
Disb3PctOther |  | numeric(6, 2) | YES |
Disb4PctOther |  | numeric(6, 2) | YES |
Disb5PctOther |  | numeric(6, 2) | YES |
Disb1PctWS |  | numeric(6, 2) | YES |
Disb2PctWS |  | numeric(6, 2) | YES |
Disb3PctWS |  | numeric(6, 2) | YES |
Disb4PctWS |  | numeric(6, 2) | YES |
Disb5PctWS |  | numeric(6, 2) | YES |
Active |  | bit | NO |
UserID |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
ts |  | timestamp | NO |
Disb10PctLoan |  | numeric(6, 2) | YES |
Disb10PctPell |  | numeric(6, 2) | YES |
Disb11PctLoan |  | numeric(6, 2) | YES |
Disb11PctPell |  | numeric(6, 2) | YES |
Disb12PctLoan |  | numeric(6, 2) | YES |
Disb12PctPell |  | numeric(6, 2) | YES |
Disb13PctLoan |  | numeric(6, 2) | YES |
Disb13PctPell |  | numeric(6, 2) | YES |
Disb14PctLoan |  | numeric(6, 2) | YES |
Disb14PctPell |  | numeric(6, 2) | YES |
Disb15PctLoan |  | numeric(6, 2) | YES |
Disb15PctPell |  | numeric(6, 2) | YES |
Disb16PctLoan |  | numeric(6, 2) | YES |
Disb17PctLoan |  | numeric(6, 2) | YES |
Disb18PctLoan |  | numeric(6, 2) | YES |
Disb19PctLoan |  | numeric(6, 2) | YES |
Disb20PctLoan |  | numeric(6, 2) | YES |
Disb6PctGrant |  | numeric(6, 2) | YES |
Disb6PctLoan |  | numeric(6, 2) | YES |
Disb6PctOther |  | numeric(6, 2) | YES |
Disb6PctPell |  | numeric(6, 2) | YES |
Disb6PctPerkins |  | numeric(6, 2) | YES |
Disb6PctWS |  | numeric(6, 2) | YES |
Disb7PctLoan |  | numeric(6, 2) | YES |
Disb7PctPell |  | numeric(6, 2) | YES |
Disb8PctLoan |  | numeric(6, 2) | YES |
Disb8PctPell |  | numeric(6, 2) | YES |
Disb9PctLoan |  | numeric(6, 2) | YES |
Disb9PctPell |  | numeric(6, 2) | YES |
DefaultMonthsinAY |  | smallint | YES |
DefaultTermsInAY |  | smallint | NO |

FaAcademicYear Primary and Unique Keys

Key Name | Key Type | Keys
FaAcademicYear_FaAcademicYearID_U_C_IDX | PrimaryKey | FaAcademicYearID

FaAcademicYear Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
FaPackMeth | Non-Identifying | Zero or One to Zero or More | FK_FaAcademicYear_FaPackMethID_FaPackMeth_FaPackMethID |  |  | FaPackMethID | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
FaAcademicYearPP | Non-Identifying | One To Zero or More | FK_FaAcademicYearPP_FaAcademicYearID_FaAcademicYear_FaAcademicYearID |  |  |  | NO | YES

FaAcademicYear Check Constraints

Check Constraint Name | CheckConstraint

FaAcademicYear Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

FaAcademicYear Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.AcademicYear | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaAcademicYear | NO |  |  |

FaAcademicYear Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

FaAcademicYear Data Movement Rules

Name | Type | Rule Text/Value